/* rebr005.p - Cumulative Orders Browse UI                                  */
/* Copyright 1986-2002 QAD Inc., Carpinteria, CA, USA.                      */
/* All rights reserved worldwide.  This is an unpublished work.             */
/* $Revision: 1.9 $    */
/*V8:ConvertMode=NoConvert                                                  */
/********************************** History *********************************
 *    Revision: 8.5      Created: 06/19/97    By: B. Pedersen    *J1TF*
 *    Revision: 8.5     Modified: 09/26/97    By: B. Pedersen    *J20C*
 *    Revision: 8.5     Modified: 01/31/99    By: Doug Norton    *M071*
 *    Revision: 9.0     Modified: 03/15/99    By: Mark Smith     *M0BF*
 *    Revision: 9.1     Modified: 08/15/00    By: Mark Brown     *N0KP*
 * $Revision: 1.9 $    BY: Jean Miller          DATE: 04/05/02  ECO: *P044*
 ****************************************************************************/

{mfdeclre.i}

&SCOPED-DEFINE BR-TITLE "Cumulative Orders"

&SCOPED-DEFINE BR-NAME re005
&SCOPED-DEFINE Q-DRAG-BACK-COL 1

&SCOPED-DEFINE Q-FIRST-TABLE wo_mstr
&SCOPED-DEFINE Q-FIRST-FIELD-LIST (wo_part wo_nbr wo_lot wo_qty_comp wo_so_job wo_status wo_site wo_line)
&SCOPED-DEFINE Q-NUM-TABLES 1

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-1 b-1.wo_part
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-1 wo_mstr.wo_part
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-1 tt-wo_part
&SCOPED-DEFINE BR-K-COL-LABEL-1 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-1 "Item Number"
&SCOPED-DEFINE BR-FIELD-TYPE-1 character
&SCOPED-DEFINE BR-FIELD-FRMT-1 FORMAT "x(18)"
&SCOPED-DEFINE BR-FIELD-WIDTH-1 19

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-2 b-1.wo_nbr
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-2 wo_mstr.wo_nbr
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-2 tt-wo_nbr
&SCOPED-DEFINE BR-K-COL-LABEL-2 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-2 "Work Order"
&SCOPED-DEFINE BR-FIELD-TYPE-2 character
&SCOPED-DEFINE BR-FIELD-FRMT-2 FORMAT "x(18)"
&SCOPED-DEFINE BR-FIELD-WIDTH-2 19

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-3 b-1.wo_lot
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-3 wo_mstr.wo_lot
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-3 tt-wo_lot
&SCOPED-DEFINE BR-K-COL-LABEL-3 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-3 "ID"
&SCOPED-DEFINE BR-FIELD-TYPE-3 character
&SCOPED-DEFINE BR-FIELD-FRMT-3 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-3 9

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-4 b-1.wo_qty_comp
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-4 wo_mstr.wo_qty_comp
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-4 tt-wo_qty_comp
&SCOPED-DEFINE BR-K-COL-LABEL-4 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-4 "Qty Comp"
&SCOPED-DEFINE BR-FIELD-TYPE-4 decimal
&SCOPED-DEFINE BR-FIELD-FRMT-4 FORMAT "->,>>>,>>9.9<<<<<<<<"
&SCOPED-DEFINE BR-FIELD-WIDTH-4 21

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-5 b-1.wo_so_job
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-5 wo_mstr.wo_so_job
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-5 tt-wo_so_job
&SCOPED-DEFINE BR-K-COL-LABEL-5 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-5 "Sales/Job"
&SCOPED-DEFINE BR-FIELD-TYPE-5 character
&SCOPED-DEFINE BR-FIELD-FRMT-5 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-5 10

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-6 b-1.wo_status
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-6 wo_mstr.wo_status
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-6 tt-wo_status
&SCOPED-DEFINE BR-K-COL-LABEL-6 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-6 "Status"
&SCOPED-DEFINE BR-FIELD-TYPE-6 character
&SCOPED-DEFINE BR-FIELD-FRMT-6 FORMAT "x(1)"
&SCOPED-DEFINE BR-FIELD-WIDTH-6 7

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-7 b-1.wo_site
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-7 wo_mstr.wo_site
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-7 tt-wo_site
&SCOPED-DEFINE BR-K-COL-LABEL-7 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-7 "Site"
&SCOPED-DEFINE BR-FIELD-TYPE-7 character
&SCOPED-DEFINE BR-FIELD-FRMT-7 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-7 9

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-8 b-1.wo_line
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-8 wo_mstr.wo_line
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-8 tt-wo_line
&SCOPED-DEFINE BR-K-COL-LABEL-8 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-8 "Prod Line"
&SCOPED-DEFINE BR-FIELD-TYPE-8 character
&SCOPED-DEFINE BR-FIELD-FRMT-8 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-8 10

&SCOPED-DEFINE Q-NUM-FILT-VALS 8
&SCOPED-DEFINE BR-MAX-FIELD-WIDTH 21
&SCOPED-DEFINE BR-BROWSE-WIDTH 104
&SCOPED-DEFINE WHERE-CLAUSE wo_type = 'C'
&SCOPED-DEFINE BR-INDEXED-FIELDS 1,2,3,7

{wbbr01.i}
if c-application-mode <> 'WEB' then do:
   {browse.i}
end.
